package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "a_real", simpleName = "", engine = MysqlDriver.InnoDB, comment = "")
public class _DDL_AReal {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.CHAR, size = 32, nullable = false, comment = "身份证号码(MD5)")
    private String id;

    @_DDL_Column(name = "name", type = SqlType.VARCHAR, size = 100, comment = "姓名(加密)")
    private String name;

    @_DDL_Column(name = "phone", type = SqlType.VARCHAR, size = 100, comment = "手机号码(加密)")
    private String phone;

    @_DDL_Column(name = "bank_card", type = SqlType.VARCHAR, size = 100, comment = "银行卡(加密)")
    private String bankCard;

    @_DDL_Column(name = "id_no", type = SqlType.VARCHAR, size = 100, comment = "身份证(加密)")
    private String idNo;

    @_DDL_Column(name = "type", type = SqlType.TINYINT_UNSIGNED, comment = "证件类型 0 身份证 1 其他")
    private Integer type;

    @_DDL_Column(name = "usr_id", type = SqlType.INT_UNSIGNED, comment = "用户id")
    private Long usrId;

}
